Re: putting the current date in a mysql db
by Kid Stevens <kstevens89(at)comcast.net>
|
Date: |
Sat, 17 Aug 2002 14:41:13 -0600 |
To: |
magic32(at)jps.net, hwg-techniques(at)mail.hwg.org |
References: |
jps |
|
todo: View
Thread,
Original
|
|
Hello Roger,
Thanks for the icdsoft tip over on evolt. If you are referring to
your site being on them the server is in Hong Kong.
At 9:27 PM -0700 8/16/02, Roger Harness wrote:
>Say I'm trying to make my own little webblog app. In my browser, I'll type
>in my journal page for the day, and submit it. This would get sent to a
>mysql database, and I could retrieve it using a simple php script.
>
>I was pretty jazzed when i first discovered the now() function, as i thought
>i could simply insert that into my database automatically, each time i
>submitted a journal page. Unfortunately, my server is in (i think) Japan, so
>obviously, its 'now()' is different then my 'now'.
>
>Soooo, would it be easier/smarter to just use a hidden javascript Date()
>script, and send it along with the contents of my form to the db, or does it
>make more sense to just subtract the correct date from the 'now()' function?
>
>And only I (actually my mother), would be utilizing this journal entry page,
>so non-javascript browsers arn't an issue. Though I would like to know the
>way most folks (would) do this.
>
>Sorry for probably such a cheesy question, and i DID google etc for an
>answer, but I wasn't able to do it by myself.
>
>as alwasy, tia,
>
>-Roger Harness
--
Sincerely,
Kid Stevens
"Warning,
Do not meddle in the affairs of Dragons.
They will make you crunchy and eat you with ketchup."
-Unknown Author
HWG hwg-techniques mailing list archives,
maintained by Webmasters @ IWA